﻿@using DCMS.Web.Extensions;
@using DCMS.Web.Framework;
@using DCMS.Web.Framework.UI;
@using DCMS.ViewModel.Models.Finances;
@using DCMS.ViewModel.Models.Sales;
@using System.Collections.Generic;
@using System.Linq;
@using DCMS.Core.Domain.Common;

@model SaleReportCostContractItemListModel

<section id="content_wrapper">

    <!-- Start: Topbar-Dropdown -->
    <div id="topbar-dropmenu">
        @await Html.PartialAsync("_ToolBox")
    </div>
    <!-- End: Topbar-Dropdown -->
    <!-- Start: Topbar -->
    <header id="topbar">
        <div class="topbar-left">
            <ol class="breadcrumb">
                <li class="crumb-active">
                    <a href="#">销售</a>
                </li>
                <li class="crumb-icon">
                    <a href="@Url.RouteUrl("HomePage")">
                        <span class="glyphicon glyphicon-home"></span>
                    </a>
                </li>
                <li class="crumb-link">
                    <a href="#">销售报表</a>
                </li>
                <li class="crumb-trail">费用合同明细表</li>
            </ol>
        </div>
        <div class="topbar-right">
            <div class="ml15 ib va-m" id="toggle_sidemenu_r">
                <a href="#" class="pl5">
                    <i class="fa fa-sign-in fs22 text-primary"></i>
                    <span class="badge badge-hero badge-danger">3</span>
                </a>
            </div>
        </div>
    </header>
    <!-- End: Topbar -->
    <!-- Begin: Content -->
    <section id="content" class="formSection">

        <div class="special-alerts">
            <div class="alert alert-danger light alert-dismissable" id="alert-demo-2" style="display: none;">
                <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                <i class="fa fa-info pr10"></i>
                <strong>您没有被授权此操作!</strong>
            </div>
        </div>

        <div class="row">
            <div class="col-md-12">

                <form asp-action="SaleReportCostContractItem" asp-controller="SaleReport" method="get" id="formSearch" novalidate="novalidate">


                    <div class="panel panel-default" id="panel0">
                        <div class="panel-heading">
                            <span class="glyphicon glyphicon-search"></span> 高级搜索
                            <a class="btn btn-default btn-sm pull-right m5 mrn p5 pbn" id="AdvancedSearch"><i class="fa fa-angle-double-right"></i></a>
                        </div>
                        <div class="panel-body p10">

                            <div class="row">
                                <div class="col-sm-2">
                                    <div class="input-group">
                                        <input asp-for="TerminalId" type="hidden" />
                                        <input asp-for="TerminalName" class="form-control" placeholder="客户..." />
                                        <span class="input-group-btn">
                                            <button id="btn_search_customer" type="button" class="btn btn-default">
                                                <span class="glyphicon glyphicon-search"></span>
                                            </button>
                                        </span>
                                    </div>
                                </div>
                                <div class="col-sm-2">
                                    <div class="input-group">
                                        <input asp-for="ProductId" type="hidden" />
                                        <input asp-for="ProductName" class="form-control" placeholder="商品名称..." />
                                        <span class="input-group-btn">
                                            <button id="btn_search_product" type="button" class="btn btn-default">
                                                <span class="glyphicon glyphicon-search"></span>
                                            </button>
                                        </span>
                                    </div>
                                </div>
                                <div class="col-sm-2">
                                    <dcms-select asp-for="BusinessUserId" asp-items="@Model.BusinessUsers" asp-default="业务员" />
                                </div>
                                <div class="col-sm-2">
                                    <div class="input-group">
                                        <input asp-for="AccountingOptionId" type="hidden" />
                                        <input asp-for="AccountingOptionName" class="form-control" placeholder="费用类别..." />
                                        <span class="input-group-btn">
                                            <button id="btn_search_accounting" type="button" class="btn btn-default">
                                                <span class="glyphicon glyphicon-search"></span>
                                            </button>
                                        </span>
                                    </div>
                                </div>
                                <div class="col-sm-2">
                                    <input asp-for="BillNumber" class="form-control" placeholder="单据编号..." />
                                </div>

                                <div class="col-sm-2">
                                    <dcms-select asp-for="CategoryId" asp-items="@Model.Categories" asp-default="商品类别" />
                                </div>

                            </div>

                            <div class="row mt10">

                                <div class="col-sm-2">
                                    <dcms-select asp-for="CashTypeId" asp-items="@Model.CashTypes" asp-default="收款方式" />
                                </div>
                                <div class="col-sm-2">
                                    <input asp-for="Remark" class="form-control" placeholder="备注..." />
                                </div>
                                <div class="col-sm-2">
                                    <dcms-select asp-for="StatusTypeId" asp-items="@Model.StatusTypes" asp-default="状态" />
                                </div>
                                <div class="col-sm-2">
                                    <dcms-editor asp-for="StartTime" placeholder="开始..." />
                                </div>
                                <div class="col-sm-2">
                                    <dcms-editor asp-for="EndTime" placeholder="结束..." />
                                </div>
                                <div class="col-sm-2">
                                    <button id="btn_query" type="submit" class="btn btn-primary btn-block">
                                        <span class="glyphicon glyphicon-search mr5" aria-hidden="true"></span>查询
                                    </button>
                                </div>

                            </div>

                        </div>
                    </div>

                </form>

                <div class="panel">
                    <div class="panel-heading">
                        <span class="panel-title">
                            <span class="glyphicon glyphicon-tasks"></span> 报表
                        </span>
                        <div class="pull-right">
                            <div class="btn-group">
                                <a id="btn_export" class="btn btn-info btn-sm mr5">
                                    <span class="glyphicon glyphicon-export mr5"></span>导出
                                </a>
                                @*<button id="btn_print" type="button" class="btn btn-alert btn-sm mr5">
                                        <span class="glyphicon glyphicon-print mr5"></span>打印
                                    </button>*@
                                <a href="@Url.Action("SaleReportCostContractItem")" class="btn btn-default btn-sm">
                                    <span class="glyphicon glyphicon-refresh mr5"></span>重置
                                </a>
                            </div>
                        </div>
                    </div>
                    <div class="panel-body p10">

                        <div class="tab-block">
                            <ul class="nav nav-tabs tabs-bg">
                                <li class="active">
                                    <a href="#tab10_1" data-toggle="tab" aria-expanded="true"><i class="fa fa-align-justify text-purple"></i> 按月兑换</a>
                                </li>
                                <li class="">
                                    <a href="#tab10_2" data-toggle="tab" aria-expanded="false"><i class="fa fa-align-justify text-purple"></i> 不按月兑换</a>
                                </li>
                            </ul>
                            <div class="tab-content">
                                <div id="tab10_1" class="tab-pane active">

                                    <table class="table table-striped table-bordered table-hover">

                                        <tr>
                                            <th class="text-center w150"><div class="th-inner">单据编号</div></th>
                                            <th class="text-left"><div class="th-inner">客户</div></th>
                                            <th class="text-left"><div class="th-inner">客户编码</div></th>
                                            <th class="text-left"><div class="th-inner">业务员</div></th>
                                            <th class="text-center"><div class="th-inner">交易时间</div></th>
                                            <th class="text-center"><div class="th-inner">审核时间</div></th>
                                            <th class="text-left"><div class="th-inner">商品/现金</div></th>
                                            <th class="text-left"><div class="th-inner">条形码</div></th>
                                            <th class="text-left"><div class="th-inner">单位换算</div></th>
                                            <th class="text-left"><div class="th-inner">单位</div></th>
                                            <th class="text-right"><div class="th-inner">1月</div></th>
                                            <th class="text-right"><div class="th-inner">2月</div></th>
                                            <th class="text-right"><div class="th-inner">3月</div></th>
                                            <th class="text-right"><div class="th-inner">4月</div></th>
                                            <th class="text-right"><div class="th-inner">5月</div></th>
                                            <th class="text-right"><div class="th-inner">6月</div></th>
                                            <th class="text-right"><div class="th-inner">7月</div></th>
                                            <th class="text-right"><div class="th-inner">8月</div></th>
                                            <th class="text-right"><div class="th-inner">9月</div></th>
                                            <th class="text-right"><div class="th-inner">10月</div></th>
                                            <th class="text-right"><div class="th-inner">11月</div></th>
                                            <th class="text-right"><div class="th-inner">12月</div></th>
                                            <th class="text-right"><div class="th-inner">总计</div></th>
                                            <th class="text-center"><div class="th-inner">状态</div></th>
                                            <th class="text-left"><div class="th-inner">备注</div></th>

                                        </tr>

                                        @{
                                            if (Model.Items.Where(i => i.ContractType == 0) != null && Model.Items.Count(i => i.ContractType == 0) > 0)
                                            {
                                                @foreach (var item in Model.Items.Where(i => i.ContractType == 0))
                                                {
                                                    <tr>
                                                        <td class="text-center">
                                                            @if (item.BillId != null && item.BillId != 0)
                                                            {
                                                                <a href="@Url.Action("Edit","CostContract",new { id= item.BillId})" target="_blank"> @item.BillNumber </a>
                                                            }
                                                        </td>
                                                        <td class="text-left">@item.TerminalName</td>
                                                        <td class="text-left">@item.TerminalCode</td>
                                                        <td class="text-left">@item.BusinessUserName</td>
                                                        <td class="text-left">@item.TransactionDate</td>
                                                        <td class="text-left">@item.AuditedDate</td>
                                                        <td class="text-left">@item.ProductName</td>
                                                        <td class="text-left">@item.BarCode</td>
                                                        <td class="text-left">@item.UnitConversion</td>
                                                        <td class="text-left">@item.UnitName</td>
                                                        <td class="text-right">￥ @((item.Jan ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Feb ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Mar ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Apr ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.May ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Jun ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Jul ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Aug ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Sep ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Oct ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Nov ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Dec ?? 0).ToString("0.00"))</td>
                                                        <td class="text-right">￥ @((item.Total ?? 0).ToString("0.00"))</td>
                                                        <td class="text-left">@item.Status</td>
                                                        <td class="text-left">@item.Remark</td>

                                                    </tr>
                                                }

                                                <tr>
                                                    <td class="text-center"><b>合计</b></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="text-left"><b>@(Model.TotalSumQuantityConversion)</b></td>
                                                    <td></td>
                                                    <td></td>

                                                </tr>
                                            }
                                            else
                                            {
                                                <tr class="no-records-found"><td class="text-center" colspan="25">没有找到匹配的记录</td></tr>
                                            }
                                        }

                                    </table>
                                    @{
                                        var pager1 = Html.Pager(Model.PagingFilteringContext).QueryParam("pagenumber");
                                    }

                                    @if (!pager1.IsEmpty())
                                    {
                                        <div class="fixed-table-pagination" style="display: block;">
                                            @Html.Raw(pager1.ToString())
                                        </div>
                                    }

                                </div>


                                <div id="tab10_2" class="tab-pane">
                                    <table class="table table-striped table-bordered table-hover">

                                        <tr>
                                            <th class="text-center w150"><div class="th-inner">单据编号</div></th>
                                            <th class="text-left"><div class="th-inner">客户</div></th>
                                            <th class="text-left"><div class="th-inner">客户编码</div></th>
                                            <th class="text-left"><div class="th-inner">业务员</div></th>
                                            <th class="text-center"><div class="th-inner">交易时间</div></th>
                                            <th class="text-center"><div class="th-inner">审核时间</div></th>
                                            <th class="text-left"><div class="th-inner">商品/现金</div></th>
                                            <th class="text-left"><div class="th-inner">条形码</div></th>
                                            <th class="text-left"><div class="th-inner">单位换算</div></th>
                                            <th class="text-left"><div class="th-inner">单位</div></th>
                                            <th class="text-right"><div class="th-inner">总计</div></th>
                                            <th class="text-center"><div class="th-inner">状态</div></th>
                                            <th class="text-left"><div class="th-inner">备注</div></th>

                                        </tr>

                                        @{
                                            if (Model.Items.Where(i => i.ContractType != 0) != null && Model.Items.Count(i => i.ContractType != 0) > 0)
                                            {
                                                @foreach (var item in Model.Items.Where(i => i.ContractType != 0))
                                                {
                                                    <tr>
                                                        <td class="text-center">
                                                            @if (item.BillId != null && item.BillId != 0)
                                                            {
                                                                <a href="@Url.Action("Edit","CostContract",new { id= item.BillId})"> @item.BillNumber </a>
                                                            }
                                                        </td>
                                                        <td class="text-left">@item.TerminalName</td>
                                                        <td class="text-left">@item.TerminalCode</td>
                                                        <td class="text-left">@item.BusinessUserName</td>
                                                        <td class="text-left">@item.TransactionDate</td>
                                                        <td class="text-left">@item.AuditedDate</td>
                                                        <td class="text-left">@item.ProductName</td>
                                                        <td class="text-left">@item.BarCode</td>
                                                        <td class="text-left">@item.UnitConversion</td>
                                                        <td class="text-left">@item.UnitName</td>
                                                        <td class="text-right">￥ @((item.Total ?? 0).ToString("0.00"))</td>
                                                        <td class="text-left">@item.Status</td>
                                                        <td class="text-left">@item.Remark</td>

                                                    </tr>
                                                }

                                                <tr>
                                                    <td class="text-center"><b>合计</b></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="text-right"><b>@(Model.TotalSumQuantityConversion)</b></td>
                                                    <td></td>
                                                    <td></td>

                                                </tr>
                                            }
                                            else
                                            {
                                                <tr class="no-records-found"><td class="text-center" colspan="13">没有找到匹配的记录</td></tr>
                                            }
                                        }
                                    </table>

                                    @{
                                        var pager2 = Html.Pager(Model.PagingFilteringContext).QueryParam("pagenumber");
                                    }

                                    @if (!pager2.IsEmpty())
                                    {
                                        <div class="fixed-table-pagination" style="display: block;">
                                            @Html.Raw(pager2.ToString())
                                        </div>
                                    }
                                </div>
                            </div>
                        </div>


                    </div>
                </div>
            </div>

        </div>

    </section>

    <!-- End: Content -->
</section>



@await Html.PartialAsync("_Windows", Model)



@await Html.PartialAsync("_Windows", Model)


@{
//Html.AddCssFileParts(ResourceLocation.Head, "~/assets/skin/default_skin/css/theme.css");
//Html.AddCssFileParts(ResourceLocation.Head, "~/Scripts/Toastr/toastr.css");
//Html.AddCssFileParts(ResourceLocation.Head, "~/Scripts/Tables/bootstrap-table.css");
//Html.AddCssFileParts(ResourceLocation.Head, "~/vendor/plugins/datepicker/css/bootstrap-datetimepicker.css");
//Html.AddCssFileParts(ResourceLocation.Head, "~/vendor/plugins/daterange/daterangepicker.css");
//Html.AddCssFileParts(ResourceLocation.Head, "~/vendor/plugins/tagmanager/tagmanager.css");
//Html.AddCssFileParts(ResourceLocation.Head, "~/vendor/plugins/fancytree/skin-win8/ui.fancytree.min.css");
//Html.AddCssFileParts(ResourceLocation.Head, "~/Content/zTree.theme.metro.min.css");
}

@section NewDefinFrameWorkScripts
{
    @{
        Html.AddScriptParts(ResourceLocation.Footer, "~/vendor/jquery/jquery-1.11.1.min.js", order: 999);
        Html.AddScriptParts(ResourceLocation.Footer, "~/vendor/jquery/jquery_ui/jquery-ui.min.js", order: 999);
        Html.AddScriptParts(ResourceLocation.Footer, "~/assets/js/bootstrap/bootstrap.min.js", order: 999);
    }
}

@section CurPageScripts
{
    @{
//Html.AddScriptParts(ResourceLocation.Footer, "~/assets/js/utility/jquery.sparkline.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/jquery.validate.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/jquery.validate.unobtrusive.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/Tables/jquery.treegrid.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/Tables/bootstrap-table.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/Tables/locale/bootstrap-table-zh-CN.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/Tables/bootstrap-table-treegrid.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/globalize.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/moment.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/moment-with-locales.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/vendor/plugins/daterange/daterangepicker.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/vendor/plugins/datepicker/js/bootstrap-datetimepicker.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/vendor/plugins/colorpicker/js/bootstrap-colorpicker.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/vendor/plugins/jquerymask/jquery.maskedinput.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/vendor/plugins/tagmanager/tagmanager.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/vendor/plugins/fancytree/jquery.fancytree-all.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/Toastr/Toastr.min.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/Scripts/Custom/Common.js");
//Html.AddScriptParts(ResourceLocation.Footer, "~/assets/js/bootstrap/holder.min.js");
    }
    <script type="text/javascript">

        jQuery(document).ready(function () {

            "use strict";

            // Init Theme Core
            Core.init();

            // Init Demo JS
            Demo.init();

            //权限提示
            if ($(this).getUrlQueryString("Authorize") == "noAuthorize") {
                $('#alert-demo-2').fadeToggle();
                setTimeout(function () {
                    $('#alert-demo-2').fadeToggle();
                }, 3000);
            }

            //高级搜索
            $("#panel0 #AdvancedSearch").click(function () {
                var ico = $(this).find(".fa");
                if (ico.hasClass('fa-angle-double-right'))
                    ico.removeClass("fa-angle-double-right").addClass("fa-angle-double-down");
                else
                    ico.removeClass("fa-angle-double-down").addClass("fa-angle-double-right");
                $("#panel0").find(".panel-body").toggleClass("hidden fadeIn");
            });

            //商品列表选择赋值
            window.operateEventsPop = {
                'click .rowSelect': function (e, value, row, index) {
                    var index = $(this).attr("data-id");
                    var keys = Object.keys(row.Units);
                    $("#ProductName").val(row.Name);
                    $("#ProductId").val(row.Id);
                    $('#ModalProductWindows').modal('hide');
                }
            };
            $("#btn_search_product").click(function () {
                $(this).productSelectShowModal($("#ModalProductWindows"), "/Product/AsyncSearchSelectPopup", null, "选择商品", $("#ProductModalForm"),
                    function () { });
            });

            //客户搜索
            $(document).on('click', "#btn_search_customer", function () {
                var actionUrl = "/Terminal/AsyncSearchSelectPopup";
                $(this).showModalV2($("#TerminalSelectModalWindow"), actionUrl, { ids: "" }, "选择终端", $("#TerminalSelectForm"), function (rows) { });
            });

            window.operateEventsPopTerminal = {
                'click .rowSelect': function (e, value, row, index) {
                    try {
                        $("#TerminalId").val(row.Id);
                        $("#TerminalName").val(row.Name);
                        $('#TerminalSelectModalWindow').modal('hide');
                    }
                    catch (err) {
                        console.log(err);
                        $(this).showToastr(err);
                        return;
                    }
                }
            };

            //会计科目选择
            $(document).on('click', "#btn_search_accounting", function () {
                var actionUrl = "/Accounting/AsyncSearchSelectPopup?type=1&ifcheck=1&accountCodeTypeIds=" + "1,2,4,75";
                var optionUrl = "/Accounting/AsyncGetAccountingOptions";
                $(this).accountingSingleSelectPopup($("#AccountingModalWindow"), actionUrl, 1, "选择科目", $("#AccountingForm"), 0, function (options) {
                    $("#AccountingOptionId").val(options[0].Id);
                    $("#AccountingOptionName").val(options[0].name);
                });
            });

            //防止重复查询
            var queryNumber = 1;
            $("#btn_query").click(function () {
                if (queryNumber > 1) {
                    return false;
                }
                queryNumber = queryNumber + 1;
            });

            //用户修改客户名称，将客户Id置零
            $("#TerminalName").bind("change", function () {
                $("#TerminalId").val(0);
            });

            //用户修改商品名称，将商品Id置零
            $("#ProductName").bind("change", function () {
                $("#ProductId").val(0);
            });

            //用户修改费用类别名称，将费用类别Id置零
            $("#AccountingOptionName").bind("change", function () {
                $("#AccountingOptionId").val(0);
            });

            //导出
            $("#btn_export").click(function () {
                window.location.href = "/SaleReport/ExportSaleReportCostContractItem?terminalId=" + $("#TerminalId").val() + "&terminalName=" + $("#TerminalName").val() + "&productId=" + $("#ProductId").val() + "&productName=" + $("#ProductName").val() + "&businessUserId=" + $("#BusinessUserId").val() + "&accountingOptionId=" + $("#AccountingOptionId").val() + "&billNumber=" + $("#BillNumber").val() + "&categoryId=" + $("#CategoryId").val() + "&cashTypeId=" + $("#CashTypeId").val() + "&remark=" + $("#Remark").val() + "&statusTypeId=" + $("#StatusTypeId").val() + "&startTime=" + $("#StartTime").val() + "&endTime=" + $("#EndTime").val();
            });
        });
    </script>
}
